import db from '../dbserver'
import Sequelize from 'sequelize'

const Service_provider = db.define('service_provider', {
    id: {
        type: Sequelize.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
    },
    service_provider_name: {
        type: Sequelize.STRING(255),
        allowNull: true
    },
    repair_personnel: {
        type: Sequelize.STRING(20),
        allowNull: true
    },
    repair_phone: {
        type: Sequelize.STRING(20),
        allowNull: true
    }
}, {
    timestamps: false,
    freezeTableName: true,
    tableName: 'service_provider'
});

export default Service_provider
